mysql -uroot -proot zjcloudtest -e "DROP TABLE IF EXISTS jwgl_school_info;" 
mysql -uroot -proot zjcloudtest -e "CREATE TABLE jwgl_school_info (school_id bigint NOT NULL AUTO_INCREMENT, school_name varchar(255) NOT NULL, school_code varchar(50) NOT NULL, address varchar(255) DEFAULT NULL, contact_person varchar(100) DEFAULT NULL, contact_phone varchar(20) DEFAULT NULL, current_semester varchar(50) DEFAULT NULL, status varchar(1) DEFAULT '0', create_by varchar(100) DEFAULT NULL, create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP, update_by varchar(100) DEFAULT NULL, update_time timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (school_id)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;" 
mysql -uroot -proot zjcloudtest -e "INSERT INTO jwgl_school_info (school_name, school_code, address, contact_person, contact_phone, status) VALUES ('智教云示范中学', 'ZJYZX', '北京市海淀区中关村科技园', '张三', '13800138000', '0'), ('智能技术学院', 'ZNJSC', '上海市浦东新区张江高科技园区', '李四', '13900139000', '0');" 
mysql -uroot -proot zjcloudtest -e "CREATE INDEX idx_school_name ON jwgl_school_info(school_name); CREATE INDEX idx_school_code ON jwgl_school_info(school_code); CREATE INDEX idx_status ON jwgl_school_info(status);" 
echo "数据库表创建成功！"